[dbo].[AsiNrdsQueue]

SQLServer > iMIS1521GA > Tables > dbo.AsiNrdsQueue

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	11:53:56 AM Tuesday, December 13, 2011
Last Modified	11:40:00 AM Monday, February 20, 2012

Columns

Name	Data Type	Max Length (Bytes)
ID	varchar(10)	10
Direction	nvarchar(20)	40
NrdsId	varchar(10)	10
RecordType	varchar(20)	20
QueuedDateTime	datetime	8

Indexes

Name	Columns
iAsiNrdsQueueID	ID

SQL Script

CREATE TABLE [dbo].[AsiNrdsQueue]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Direction] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NrdsId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RecordType] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QueuedDateTime] [datetime] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iAsiNrdsQueueID] ON [dbo].[AsiNrdsQueue] ([ID]) ON [PRIMARY]
GO

Uses